{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Баланс энергии","Баланс мощности"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":11,"defined_names":1543,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Баланс энергии","index":0,"n_rows":25,"n_cols":50,"rows_kept":25,"cut":false,"hidden":false,"merged":[[18,49,19,52],[4,22,4,26],[4,27,4,31],[4,32,4,36],[4,37,4,41],[4,42,4,46],[16,49,16,52],[1,5,1,6],[1,10,1,11],[2,0,2,6],[2,7,2,46],[4,0,5,0],[4,1,5,1],[4,2,4,6],[4,7,4,11],[4,12,4,16],[4,17,4,21]]}
["Заполняется в тыс. кВт.ч. !",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"тыс. кВт.ч."]
[]
["Баланс электрической энергии по сетям ВН, СН1, СН2, и НН",null,null,null,null,null,null,{"$f":"'[1]Инф-я'!C12","v":"МУП «Горэлектросеть» г. Муром"}]
[]
["№ п.п.","Показатели","Принято регулирующим органом на 2019 год",null,null,null,null,"Факт за 2019 год",null,null,null,null,"Принято регулирующим органом на 2020 год",null,null,null,null,"По данным организации на 2021 год",null,null,null,null,"По данным организации на 1 полугодие 2021 года",null,null,null,null,"По данным организации на 2 полугодие 2021 года",null,null,null,null,"По данным экспертов на 2021 год",null,null,null,null,"По данным экспертов  на 1 полугодие 2021 года",null,null,null,null,"По данным экспертов на 2 полугодие 2021 года"]
[null,null,"Всего","ВН","СН1","СН2","НН","Всего","ВН","СН1","СН2","НН","Всего","ВН","СН1","СН2","НН","Всего","ВН","СН1","СН2","НН","Всего","ВН","СН1","СН2","НН","Всего","ВН","СН1","СН2","НН","Всего","ВН","СН1","СН2","НН","Всего","ВН","СН1","СН2","НН","Всего","ВН","СН1","СН2","НН"]
[1,2,3,4,5,6,7,18,19,20,21,22,33,34,35,36,37,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,53,54,55,56,57,58,59,60,61,62]
["1.","Поступление эл.энергии в сеть , ВСЕГО ",{"$f":"C18+C20+C21","v":194127.09999999998},{"$f":"D14+D15+D16+D17","v":191686.5},{"$f":"E9+E14+E15+E16+E17","v":2440.6},{"$f":"F9+F14+F15+F16+F17","v":194127.1},{"$f":"G9+G14+G15+G16+G17","v":110438.7901570681},{"$f":"H18+H20+H21","v":180556.003},{"$f":"I14+I15+I16+I17","v":177738.57},{"$f":"J9+J14+J15+J16+J17","v":2687.6419999999998},{"$f":"K9+K14+K15+K16+K17","v":180556.003},{"$f":"L9+L14+L15+L16+L17","v":102866.1980558801},{"$f":"M18+M20+M21","v":183841.1567929211},{"$f":"N14+N15+N16+N17","v":181665.5276146096},{"$f":"O9+O14+O15+O16+O17","v":2175.6291783114925},{"$f":"P9+P14+P15+P16+P17","v":183841.1567929211},{"$f":"Q9+Q14+Q15+Q16+Q17","v":105192.82098742858},{"$f":"R18+R20+R21","v":180556.003},{"$f":"S14+S15+S16+S17","v":177738.57},{"$f":"T9+T14+T15+T16+T17","v":2687.6419999999998},{"$f":"U9+U14+U15+U16+U17","v":180556.003},{"$f":"V9+V14+V15+V16+V17","v":102866.1980558801},{"$f":"W18+W20+W21","v":90463.591000000015},{"$f":"X14+X15+X16+X17","v":89068.851500000004},{"$f":"Y9+Y14+Y15+Y16+Y17","v":1329.8440000000001},{"$f":"Z9+Z14+Z15+Z16+Z17","v":90463.591},{"$f":"AA9+AA14+AA15+AA16+AA17","v":51799.188129820584},{"$f":"AB18+AB20+AB21","v":90092.411999999997},{"$f":"AC14+AC15+AC16+AC17","v":88669.718500000003},{"$f":"AD9+AD14+AD15+AD16+AD17","v":1357.798},{"$f":"AE9+AE14+AE15+AE16+AE17","v":90092.411999999997},{"$f":"AF9+AF14+AF15+AF16+AF17","v":51067.009902433521},{"$f":"AG18+AG20+AG21","v":179315.8864815683},{"$f":"AH14+AH15+AH16+AH17","v":176517.80451473713},{"$f":"AI9+AI14+AI15+AI16+AI17","v":2669.1824130327877},{"$f":"AJ9+AJ14+AJ15+AJ16+AJ17","v":179315.88648156833},{"$f":"AK9+AK14+AK15+AK16+AK17","v":101856.8472431702},{"$f":"AL18+AL20+AL21","v":89966.415806443285},{"$f":"AM14+AM15+AM16+AM17","v":88562.561353679397},{"$f":"AN9+AN14+AN15+AN16+AN17","v":1339.1829332357383},{"$f":"AO9+AO14+AO15+AO16+AO17","v":89966.41580644327},{"$f":"AP9+AP14+AP15+AP16+AP17","v":50805.704352386128},{"$f":"AQ18+AQ20+AQ21","v":89349.470675125092},{"$f":"AR14+AR15+AR16+AR17","v":87955.243161057733},{"$f":"AS9+AS14+AS15+AS16+AS17","v":1329.9994797970494},{"$f":"AT9+AT14+AT15+AT16+AT17","v":89349.470675125092},{"$f":"AU9+AU14+AU15+AU16+AU17","v":51051.142890784111}]
["1.1.","из смежной сети, всего","х","х",{"$f":"E11","v":0},{"$f":"F11+F12","v":194127.1},{"$f":"G11+G12+G13","v":110438.7901570681},"х","х",{"$f":"J11","v":0},{"$f":"K11+K12","v":180426.212},{"$f":"L11+L12+L13","v":102866.1980558801},"х","х",{"$f":"O11","v":0},{"$f":"P11+P12","v":183841.1567929211},{"$f":"Q11+Q12+Q13","v":105192.82098742858},"х","х",{"$f":"T11","v":0},{"$f":"U11+U12","v":180426.212},{"$f":"V11+V12+V13","v":102866.1980558801},"х","х",{"$f":"Y11","v":0},{"$f":"Z11+Z12","v":90398.695500000002},{"$f":"AA11+AA12+AA13","v":51799.188129820584},"х","х",{"$f":"AD11","v":0},{"$f":"AE11+AE12","v":90027.516499999998},{"$f":"AF11+AF12+AF13","v":51067.009902433521},"х","х",{"$f":"AI11","v":0},{"$f":"AJ11+AJ12","v":179186.9869277699},{"$f":"AK11+AK12+AK13","v":101856.8472431702},"х","х",{"$f":"AN11","v":0},{"$f":"AO11+AO12","v":89901.744286915142},{"$f":"AP11+AP12+AP13","v":50805.704352386128},"х","х",{"$f":"AS11","v":0},{"$f":"AT11+AT12","v":89285.242640854776},{"$f":"AU11+AU12+AU13","v":51051.142890784111}]
[null,"    в том числе из сети","х","х","х","х","х","х","х","х","х","х","х","х","х","х","х","х","х","х","х","х","х","х","х","х","х","х","х","х","х","х","х","х","х","х","х","х","х","х","х","х","х","х","х","х","х"]
["1.1.1.","ВН","х","х",null,{"$f":"D8-D18-D20-D21-E11-G11","v":191686.5},null,"х","х",null,{"$f":"I8-I18-I20-I21-J11-L11","v":177738.57},null,"х","х",null,{"$f":"N8-N18-N20-N21-O11-Q11","v":181665.5276146096},null,"х","х",null,{"$f":"S8-S18-S20-S21-T11-V11","v":177738.57},null,"х","х",null,{"$f":"X8-X18-X20-X21-Y11-AA11","v":89068.851500000004},null,"х","х",null,{"$f":"AC8-AC18-AC20-AC21-AD11-AF11","v":88669.718500000003},null,"х","х",null,{"$f":"AH8-AH18-AH20-AH21-AI11-AK11","v":176517.80451473713},null,"х","х",null,{"$f":"AM8-AM18-AM20-AM21-AN11-AP11","v":88562.561353679397},null,"х","х",null,{"$f":"AR8-AR18-AR20-AR21-AS11-AU11","v":87955.243161057733}]
["1.1.2.","СН1","х","х","х",{"$f":"E8-E18-E20-E21-G12","v":2440.6},null,"х","х","х",{"$f":"J8-J18-J20-J21-L12","v":2687.6419999999998},null,"х","х","х",{"$f":"O8-O18-O20-O21-Q12","v":2175.6291783114925},null,"х","х","х",{"$f":"T8-T18-T20-T21-V12","v":2687.6419999999998},null,"х","х","х",{"$f":"Y8-Y18-Y20-Y21-AA12","v":1329.8440000000001},null,"х","х","х",{"$f":"AD8-AD18-AD20-AD21-AF12","v":1357.798},null,"х","х","х",{"$f":"AI8-AI18-AI20-AI21-AK12","v":2669.1824130327877},null,"х","х","х",{"$f":"AN8-AN18-AN20-AN21-AP12","v":1339.1829332357383},null,"х","х","х",{"$f":"AS8-AS18-AS20-AS21-AU12","v":1329.9994797970494}]
["1.1.3.","СН2","х","х","х","х",{"$f":"F8-F18-F20-F21","v":110438.7901570681},"х","х","х","х",{"$f":"K8-K18-K20-K21","v":102866.1980558801},"х","х","х","х",{"$f":"P8-P18-P20-P21","v":105192.82098742858},"х","х","х","х",{"$f":"U8-U18-U20-U21","v":102866.1980558801},"х","х","х","х",{"$f":"Z8-Z18-Z20-Z21","v":51799.188129820584},"х","х","х","х",{"$f":"AE8-AE18-AE20-AE21","v":51067.009902433521},"х","х","х","х",{"$f":"AJ8-AJ18-AJ20-AJ21","v":101856.8472431702},"х","х","х","х",{"$f":"AO8-AO18-AO20-AO21","v":50805.704352386128},"х","х","х","х",{"$f":"AT8-AT18-AT20-AT21","v":51051.142890784111}]
["1.2.","от электростанций",{"$f":"SUM(D14:G14)","v":0},null,null,null,null,{"$f":"SUM(I14:L14)","v":0},null,null,null,null,{"$f":"SUM(N14:Q14)","v":0},null,null,null,null,{"$f":"SUM(S14:V14)","v":0},null,null,null,null,{"$f":"SUM(X14:AA14)","v":0},null,null,null,null,{"$f":"SUM(AC14:AF14)","v":0},null,null,null,null,{"$f":"SUM(AH14:AK14)","v":0},null,null,null,null,{"$f":"SUM(AM14:AP14)","v":0},null,null,null,null,{"$f":"SUM(AR14:AU14)","v":0}]
["1.3.","от ОАО \"ФСК ЕЭС\"",{"$f":"SUM(D15:G15)","v":0},null,null,null,null,{"$f":"SUM(I15:L15)","v":0},null,null,null,null,{"$f":"SUM(N15:Q15)","v":0},null,null,null,null,{"$f":"SUM(S15:V15)","v":0},null,null,null,null,{"$f":"SUM(X15:AA15)","v":0},null,null,null,null,{"$f":"SUM(AC15:AF15)","v":0},null,null,null,null,{"$f":"SUM(AH15:AK15)","v":0},null,null,null,null,{"$f":"SUM(AM15:AP15)","v":0},null,null,null,null,{"$f":"SUM(AR15:AU15)","v":0}]
["1.4.","от филиала \"Владимирэнерго\" ОАО \"МРСК Центра и Приволжья\" ",{"$f":"SUM(D16:G16)","v":194127.1},{"$f":"191.6865*1000","v":191686.5},{"$f":"2.4406*1000","v":2440.6},null,null,{"$f":"SUM(I16:L16)","v":180556.003},177738.57,2687.6419999999998,129.791,null,{"$f":"SUM(N16:Q16)","v":183841.1567929211},181665.5276146096,2175.6291783114925,null,null,{"$f":"SUM(S16:V16)","v":180556.003},177738.57,2687.6419999999998,129.791,null,{"$f":"SUM(X16:AA16)","v":90463.591},89068.851500000004,1329.8440000000001,64.895499999999998,null,{"$f":"SUM(AC16:AF16)","v":90092.411999999997},88669.718500000003,1357.798,64.895499999999998,null,{"$f":"SUM(AH16:AK16)","v":179315.88648156833},176517.80451473713,2669.1824130327877,128.89955379843693,0,{"$f":"SUM(AM16:AP16)","v":89966.41580644327},88562.561353679397,1339.1829332357383,64.671519528121578,0,{"$f":"SUM(AR16:AU16)","v":89349.470675125092},87955.243161057733,1329.9994797970494,64.228034270315348,0]
["1.5.","от других сетевых организаций",{"$f":"SUM(D17:G17)","v":0},null,null,null,null,{"$f":"SUM(I17:L17)","v":0},null,null,null,null,{"$f":"SUM(N17:Q17)","v":0},null,null,null,null,{"$f":"SUM(S17:V17)","v":0},null,null,null,null,{"$f":"SUM(X17:AA17)","v":0},null,null,null,null,{"$f":"SUM(AC17:AF17)","v":0},null,null,null,null,{"$f":"SUM(AH17:AK17)","v":0},null,null,null,null,{"$f":"SUM(AM17:AP17)","v":0},null,null,null,null,{"$f":"SUM(AR17:AU17)","v":0},null,null,null,null,null,null,"Уровень потерь на 2020-2024 гг."]
["2.","Потери электроэнергии в сети ",{"$f":"SUM(D18:G18)","v":21689.800000000003},{"$f":"D8*D19/100","v":0},{"$f":"E8*E19/100","v":0},{"$f":"F8*F19/100","v":11142.89554},{"$f":"G8*G19/100","v":10546.904460000005},{"$f":"SUM(I18:L18)","v":13598.615997316918},{"$f":"I8*I19/100","v":0},{"$f":"J8*J19/100","v":0},{"$f":"K8*K19/100","v":6927.0859441199118},{"$f":"L8*L19/100","v":6671.5300531970061},{"$f":"SUM(N18:Q18)","v":13475.599999999999},{"$f":"N8*N19/100","v":0},{"$f":"O8*O19/100","v":0},{"$f":"P8*P19/100","v":7206.5733462825065},{"$f":"Q8*Q19/100","v":6269.026653717493},{"$f":"SUM(S18:V18)","v":13598.615997316918},{"$f":"S8*S19/100","v":0},{"$f":"T8*T19/100","v":0},{"$f":"U8*U19/100","v":6927.0859441199118},{"$f":"V8*V19/100","v":6671.5300531970061},{"$f":"SUM(X18:AA18)","v":5953.2809771901502},{"$f":"X8*X19/100","v":0},{"$f":"Y8*Y19/100","v":0},{"$f":"Z8*Z19/100","v":3025.023870179421},{"$f":"AA8*AA19/100","v":2928.2571070107288},{"$f":"SUM(AC18:AF18)","v":7645.3350506257066},{"$f":"AC8*AC19/100","v":0},{"$f":"AD8*AD19/100","v":0},{"$f":"AE8*AE19/100","v":3902.062097566476},{"$f":"AF8*AF19/100","v":3743.2729530592305},{"$f":"SUM(AH18:AK18)","v":13143.899999999998},{"$f":"AH8*AH19/100","v":0},{"$f":"AI8*AI19/100","v":0},{"$f":"AJ8*AJ19/100","v":7029.182750077478},{"$f":"AK8*AK19/100","v":6114.7172499225208},{"$f":"SUM(AM18:AP18)","v":5891.6},{"$f":"AM8*AM19/100","v":0},{"$f":"AN8*AN19/100","v":0},{"$f":"AO8*AO19/100","v":3526.6834996125758},{"$f":"AP8*AP19/100","v":2364.9165003874245},{"$f":"SUM(AR18:AU18)","v":7252.2999999999993},{"$f":"AR8*AR19/100","v":0},{"$f":"AS8*AS19/100","v":0},{"$f":"AT8*AT19/100","v":3502.4992504649035},{"$f":"AU8*AU19/100","v":3749.8007495350962}]
["2.1.","то же в % (п.2./п.1.)",{"$f":"IF(C8=0,0,C18/C8*100)","v":11.172989242614765},null,null,5.74,9.5500000000000007,{"$f":"IF(H8=0,0,H18/H8*100)","v":7.5315225034732949},null,null,3.8365304,6.4856388000000003,{"$f":"IF(M8=0,0,M18/M8*100)","v":7.3300235023971965},null,null,3.92,5.959557501045337,{"$f":"IF(R8=0,0,R18/R8*100)","v":7.5315225034732949},null,null,3.8365304,6.4856388000000003,{"$f":"IF(W8=0,0,W18/W8*100)","v":6.5808585657296632},null,null,3.3439131,5.6530946000000002,{"$f":"IF(AB8=0,0,AB18/AB8*100)","v":8.4861031921597423},null,null,4.3311773000000002,7.3301197,{"$f":"IF(AG8=0,0,AG18/AG8*100)","v":7.3300253858717896},null,null,3.92,6.0032461394808498,{"$f":"IF(AL8=0,0,AL18/AL8*100)","v":6.5486659073707933},null,null,3.92,4.6548247495684105,{"$f":"IF(AQ8=0,0,AQ18/AQ8*100)","v":8.1167800382045705},null,null,3.92,7.3451847249672841,null,null,7.3300000000000045]
["3.","Расход электроэнергии на производственные и хознужды",{"$f":"SUM(D20:G20)","v":0},null,null,null,null,{"$f":"SUM(I20:L20)","v":0},null,null,null,null,{"$f":"SUM(N20:Q20)","v":0},null,null,null,null,{"$f":"SUM(S20:V20)","v":0},null,null,null,null,{"$f":"SUM(X20:AA20)","v":0},null,null,null,null,{"$f":"SUM(AC20:AF20)","v":0},null,null,null,null,{"$f":"SUM(AH20:AK20)","v":0},null,null,null,null,{"$f":"SUM(AM20:AP20)","v":0},null,null,null,null,{"$f":"SUM(AR20:AU20)","v":0}]
["4.","Полезный отпуск из сети ",{"$f":"SUM(D21:G21)","v":172437.3},{"$f":"D22+D23+D24","v":0},{"$f":"E22+E23+E24","v":0},{"$f":"F22+F23+F24","v":72545.414302931909},{"$f":"G8-G18-G20","v":99891.885697068094},{"$f":"SUM(I21:L21)","v":166957.38700268307},{"$f":"I22+I23+I24","v":0},{"$f":"J22+J23+J24","v":0},{"$f":"K22+K23+K24","v":70762.718999999997},{"$f":"L8-L18-L20","v":96194.668002683087},{"$f":"SUM(N21:Q21)","v":170365.5567929211},{"$f":"N22+N23+N24","v":0},{"$f":"O22+O23+O24","v":0},{"$f":"P22+P23+P24","v":71441.762459210018},{"$f":"Q8-Q18-Q20","v":98923.794333711092},{"$f":"SUM(S21:V21)","v":166957.38700268307},{"$f":"S22+S23+S24","v":0},{"$f":"T22+T23+T24","v":0},{"$f":"U22+U23+U24","v":70762.718999999997},{"$f":"V8-V18-V20","v":96194.668002683087},{"$f":"SUM(X21:AA21)","v":84510.310022809863},{"$f":"X22+X23+X24","v":0},{"$f":"Y22+Y23+Y24","v":0},{"$f":"Z22+Z23+Z24","v":35639.379000000001},{"$f":"AA8-AA18-AA20","v":48870.931022809855},{"$f":"SUM(AC21:AF21)","v":82447.076949374285},{"$f":"AC22+AC23+AC24","v":0},{"$f":"AD22+AD23+AD24","v":0},{"$f":"AE22+AE23+AE24","v":35123.339999999997},{"$f":"AF8-AF18-AF20","v":47323.736949374288},{"$f":"SUM(AH21:AK21)","v":166171.98648156831},{"$f":"AH22+AH23+AH24","v":0},{"$f":"AI22+AI23+AI24","v":0},{"$f":"AJ22+AJ23+AJ24","v":70429.856488320656},{"$f":"AK8-AK18-AK20","v":95742.129993247669},{"$f":"SUM(AM21:AP21)","v":84074.815806443279},{"$f":"AM22+AM23+AM24","v":0},{"$f":"AN22+AN23+AN24","v":0},{"$f":"AO22+AO23+AO24","v":35634.027954444573},{"$f":"AP8-AP18-AP20","v":48440.787851998706},{"$f":"SUM(AR21:AU21)","v":82097.170675125089},{"$f":"AR22+AR23+AR24","v":0},{"$f":"AS22+AS23+AS24","v":0},{"$f":"AT22+AT23+AT24","v":34795.828533876083},{"$f":"AU8-AU18-AU20","v":47301.342141249013}]
["4.1.","потребителям, присоединенным к сети",{"$f":"SUM(D22:G22)","v":172437.30000000002},null,null,{"$f":"72.5454143029319*1000","v":72545.414302931909},{"$f":"99.8918856970681*1000","v":99891.885697068108},{"$f":"SUM(I22:L22)","v":159963.571},null,null,64634.938000000002,95328.633000000002,{"$f":"SUM(N22:Q22)","v":170365.5567929211},null,null,71441.762459210018,98923.794333711092,{"$f":"SUM(S22:V22)","v":166957.38699999999},null,null,70762.718999999997,96194.668000000005,{"$f":"SUM(X22:AA22)","v":84510.31},null,null,35639.379000000001,48870.930999999997,{"$f":"SUM(AC22:AF22)","v":82447.07699999999},null,null,35123.339999999997,47323.737000000001,{"$f":"SUM(AH22:AK22)","v":159211.11438481178},0,0,64330.900109583177,94880.214275228587,{"$f":"SUM(AM22:AP22)","v":80552.958411713655},0,0,32548.257332025241,48004.701079688406,{"$f":"SUM(AR22:AU22)","v":78658.155973098124},0,0,31782.642777557936,46875.513195540181]
["4.2.","переток в филиал \"Владимирэнерго\" ОАО \"МРСК Центра и Приволжья\" ",{"$f":"SUM(D23:G23)","v":0},null,null,null,null,{"$f":"SUM(I23:L23)","v":0},null,null,null,null,{"$f":"SUM(N23:Q23)","v":0},null,null,null,null,{"$f":"SUM(S23:V23)","v":0},null,null,null,null,{"$f":"SUM(X23:AA23)","v":0},null,null,null,null,{"$f":"SUM(AC23:AF23)","v":0},null,null,null,null,{"$f":"SUM(AH23:AK23)","v":0},0,0,0,0,{"$f":"SUM(AM23:AP23)","v":0},0,0,0,0,{"$f":"SUM(AR23:AU23)","v":0},0,0,0,0]
["4.3.","переток в другие сетевые организации",{"$f":"SUM(D24:G24)","v":0},null,null,null,null,{"$f":"SUM(I24:L24)","v":6993.8159999999998},null,null,6127.7809999999999,866.03499999999997,{"$f":"SUM(N24:Q24)","v":0},null,null,null,null,{"$f":"SUM(S24:V24)","v":0},null,null,null,null,{"$f":"SUM(X24:AA24)","v":0},null,null,null,null,{"$f":"SUM(AC24:AF24)","v":0},null,null,null,null,{"$f":"SUM(AH24:AK24)","v":6960.8720967565623},0,0,6098.9563787374809,861.9157180190814,{"$f":"SUM(AM24:AP24)","v":3521.8573947295986},0,0,3085.7706224193312,436.08677231026758,{"$f":"SUM(AR24:AU24)","v":3439.0147020269637},0,0,3013.1857563181497,425.82894570881382]
[null,"Проверка",null,{"$f":"D8-D18-D20-D22-D23-D24-E11-F11-G11","v":0},{"$f":"E8-E18-E20-E22-E23-E24-F12-G12","v":0},{"$f":"F8-F18-F20-F22-F23-F24-G13","v":0},{"$f":"G8-G18-G20-G22-G23-G24","v":-1.4551915228366852E-11},null,{"$f":"I8-I18-I20-I22-I23-I24-J11-K11-L11","v":0},{"$f":"J8-J18-J20-J22-J23-J24-K12-L12","v":0},{"$f":"K8-K18-K20-K22-K23-K24-L13","v":0},{"$f":"L8-L18-L20-L22-L23-L24","v":2.6830856540982495E-6},null,{"$f":"N8-N18-N20-N22-N23-N24-O11-P11-Q11","v":0},{"$f":"O8-O18-O20-O22-O23-O24-P12-Q12","v":0},{"$f":"P8-P18-P20-P22-P23-P24-Q13","v":0},{"$f":"Q8-Q18-Q20-Q22-Q23-Q24","v":0},null,{"$f":"S8-S18-S20-S22-S23-S24-T11-U11-V11","v":0},{"$f":"T8-T18-T20-T22-T23-T24-U12-V12","v":0},{"$f":"U8-U18-U20-U22-U23-U24-V13","v":0},{"$f":"V8-V18-V20-V22-V23-V24","v":2.6830821298062801E-6},null,{"$f":"X8-X18-X20-X22-X23-X24-Y11-Z11-AA11","v":0},{"$f":"Y8-Y18-Y20-Y22-Y23-Y24-Z12-AA12","v":0},{"$f":"Z8-Z18-Z20-Z22-Z23-Z24-AA13","v":0},{"$f":"AA8-AA18-AA20-AA22-AA23-AA24","v":2.2809857910033315E-5},null,{"$f":"AC8-AC18-AC20-AC22-AC23-AC24-AD11-AE11-AF11","v":0},{"$f":"AD8-AD18-AD20-AD22-AD23-AD24-AE12-AF12","v":0},{"$f":"AE8-AE18-AE20-AE22-AE23-AE24-AF13","v":0},{"$f":"AF8-AF18-AF20-AF22-AF23-AF24","v":-5.0625712901819497E-5},null,{"$f":"AH8-AH18-AH20-AH22-AH23-AH24-AI11-AJ11-AK11","v":0},{"$f":"AI8-AI18-AI20-AI22-AI23-AI24-AJ12-AK12","v":0},{"$f":"AJ8-AJ18-AJ20-AJ22-AJ23-AJ24-AK13","v":0},{"$f":"AK8-AK18-AK20-AK22-AK23-AK24","v":0},null,{"$f":"AM8-AM18-AM20-AM22-AM23-AM24-AN11-AO11-AP11","v":0},{"$f":"AN8-AN18-AN20-AN22-AN23-AN24-AO12-AP12","v":0},{"$f":"AO8-AO18-AO20-AO22-AO23-AO24-AP13","v":0},{"$f":"AP8-AP18-AP20-AP22-AP23-AP24","v":3.2571279007242993E-11},null,{"$f":"AR8-AR18-AR20-AR22-AR23-AR24-AS11-AT11-AU11","v":0},{"$f":"AS8-AS18-AS20-AS22-AS23-AS24-AT12-AU12","v":0},{"$f":"AT8-AT18-AT20-AT22-AT23-AT24-AU13","v":0},{"$f":"AU8-AU18-AU20-AU22-AU23-AU24","v":1.8360424292040989E-11}]

{"sheet":"Баланс мощности","index":1,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[[1,1,1,6],[2,1,2,5],[5,0,6,0],[5,1,6,1],[5,2,5,6],[5,7,5,11]]}
[]
[null,"Электрическая мощность по диапазонам напряжения "]
[null,{"$f":"'[1]Инф-я'!C12","v":"МУП «Горэлектросеть» г. Муром"}]
[]
[null,null,null,null,null,null,"МВт"]
["№ п.п.","Показатели","По данным организации на 2021 год",null,null,null,null,"По данным экспертов на 2021 год"]
[null,null,"Всего","ВН","СН1","СН2","НН","Всего","ВН","СН1","СН2","НН"]
[1,2,3,4,5,6,7,8,9,10,11,12]
["1.","Поступление мощности в сеть , ВСЕГО ",{"$f":"C19+C21+C22","v":29.1252},{"$f":"D15+D16+D17+D18","v":28.670724400000001},{"$f":"E10+E15+E16+E17+E18","v":0.43353920000000001},{"$f":"F10+F15+F16+F17+F18","v":29.1252},{"$f":"G10+G15+G16+G17+G18","v":16.593181847939199},{"$f":"H19+H21+H22","v":29.125200191263485},{"$f":"I15+I16+I17+I18","v":28.670724400000001},{"$f":"J10+J15+J16+J17+J18","v":0.43353920000000001},{"$f":"K10+K15+K16+K17+K18","v":29.1252},{"$f":"L10+L15+L16+L17+L18","v":16.593181847939199}]
["1.1.","из смежной сети, всего","х","х",{"$f":"E12","v":0},{"$f":"F12+F13","v":29.104263599999999},{"$f":"G12+G13+G14","v":16.593181847939199},"х","х",{"$f":"J12","v":0},{"$f":"K12+K13","v":29.104263599999999},{"$f":"L12+L13+L14","v":16.593181847939199}]
[null,"    в том числе из сети","х","х","х","х","х","х","х","х","х","х"]
["1.1.1.","ВН","х","х",null,{"$f":"D9-D19-D21-D22-G12-E12","v":28.670724400000001},null,"х","х",null,{"$f":"I9-I19-I21-I22-L12-J12","v":28.670724400000001}]
["1.1.2.","СН1","х","х","х",{"$f":"E9-E19-E21-E22-G13","v":0.43353920000000001},null,"х","х","х",{"$f":"J9-J19-J21-J22-L13","v":0.43353920000000001}]
["1.1.3.","СН2","х","х","х","х",{"$f":"F9-F19-F21-F22","v":16.593181847939199},"х","х","х","х",{"$f":"K9-K19-K21-K22","v":16.593181847939199}]
["1.2.","от электростанций",{"$f":"SUM(D15:G15)","v":0},null,null,null,null,{"$f":"SUM(I15:L15)","v":0}]
["1.3.","от ОАО \"ФСК ЕЭС\"",{"$f":"SUM(D16:G16)","v":0},null,null,null,null,{"$f":"SUM(I16:L16)","v":0}]
["1.4.","от филиала \"Владимирэнерго\" ОАО \"МРСК Центра и Приволжья\" ",{"$f":"SUM(D17:G17)","v":29.1252},28.670724400000001,0.43353920000000001,2.0936400000000001E-2,null,{"$f":"SUM(I17:L17)","v":29.1252},28.670724400000001,0.43353920000000001,2.0936400000000001E-2]
["1.5.","от других сетевых организаций",{"$f":"SUM(D18:G18)","v":0},null,null,null,null,{"$f":"SUM(I18:L18)","v":0}]
["2.","Потери мощности в сети ",{"$f":"SUM(D19:G19)","v":2.1935711912634837},{"$f":"D9*D20/100","v":0},{"$f":"E9*E20/100","v":0},{"$f":"F9*F20/100","v":1.1173971520607999},{"$f":"G9*G20/100","v":1.076174039202684},{"$f":"SUM(I19:L19)","v":2.1935711912634837},{"$f":"I9*I20/100","v":0},{"$f":"J9*J20/100","v":0},{"$f":"K9*K20/100","v":1.1173971520607999},{"$f":"L9*L20/100","v":1.076174039202684}]
["2.1.","то же в % (п.2./п.1.)",{"$f":"IF(C9=0,0,C19/C9*100)","v":7.5315231870115351},{"$f":"'Баланс энергии'!S19","v":0},{"$f":"'Баланс энергии'!T19","v":0},{"$f":"'Баланс энергии'!U19","v":3.8365304},6.4856400000000001,{"$f":"IF(H9=0,0,H19/H9*100)","v":7.5315231375524636},{"$f":"'Баланс энергии'!AH19","v":0},{"$f":"'Баланс энергии'!AI19","v":0},{"$f":"F20","v":3.8365304},{"$f":"G20","v":6.4856400000000001}]
["3.","Расход электроэнергии на производственные и хознужды",{"$f":"SUM(D21:G21)","v":0},null,null,null,null,{"$f":"SUM(I21:L21)","v":0}]
["4.","Полезный отпуск из сети ",{"$f":"SUM(D22:G22)","v":26.931628808736516},{"$f":"D23+D24+D25","v":0},{"$f":"E23+E24+E25","v":0},{"$f":"F23+F24+F25","v":11.414621},{"$f":"G9-G19-G21","v":15.517007808736516},{"$f":"SUM(I22:L22)","v":26.931629000000001},{"$f":"I23+I24+I25","v":0},{"$f":"J23+J24+J25","v":0},{"$f":"K23+K24+K25","v":11.414621},{"$f":"L23","v":15.517008000000001}]
["4.1.","потребителям, присоединенным к сети",{"$f":"SUM(D23:G23)","v":26.931629000000001},null,null,11.414621,15.517008000000001,{"$f":"SUM(I23:L23)","v":26.931629000000001},null,null,11.414621,15.517008000000001]
["4.2.","переток в филиал \"Владимирэнерго\" ОАО \"МРСК Центра и Приволжья\" ",{"$f":"SUM(D24:G24)","v":0},null,null,null,null,{"$f":"SUM(I24:L24)","v":0}]
["4.3.","переток в другие сетевые организации",{"$f":"SUM(D25:G25)","v":0},null,null,null,null,{"$f":"SUM(I25:L25)","v":0}]
[null,"Проверка",null,{"$f":"D9-D19-D21-D23-D24-D25-E12-F12-G12","v":0},{"$f":"E9-E19-E21-E23-E24-E25-F13-G13","v":0},{"$f":"F9-F19-F21-F23-F24-F25-G14","v":0},{"$f":"G9-G19-G21-G23-G24-G25","v":-1.9126348504983071E-7},null,{"$f":"I9-I19-I21-I23-I24-I25-J12-K12-L12","v":0},{"$f":"J9-J19-J21-J23-J24-J25-K13-L13","v":0},{"$f":"K9-K19-K21-K23-K24-K25-L14","v":0},{"$f":"L9-L19-L21-L23-L24-L25-M14","v":-1.9126348504983071E-7}]